﻿/****** Object:  Table [dbo].[TvShow_FileMatchTypes]    Script Date: 11/23/2011 11:56:14 ******/
INSERT [dbo].[TvShow_FileMatchTypes] ([Id], [Type]) VALUES (1, N'ShowTitle + dash + Season + dotNoSpace + EpisodeZero + Episode + EpisodeTitle +')
INSERT [dbo].[TvShow_FileMatchTypes] ([Id], [Type]) VALUES (2, N'ShowTitle + SeasonLetter + SeasonZero + SeasonNoSpace + EpisodeLetterNoSpace + EpisodeZero + Episode +')
INSERT [dbo].[TvShow_FileMatchTypes] ([Id], [Type]) VALUES (3, N'ShowTitle + dash + Season + xNoSpace + EpisodeZero + Episode +')
INSERT [dbo].[TvShow_FileMatchTypes] ([Id], [Type]) VALUES (4, N'ShowTitle + SeasonLetter + SeasonZero + SeasonNoSpace + EpisodeLetter + EpisodeZero + Episode + dash + EpisodeTitle +')
INSERT [dbo].[TvShow_FileMatchTypes] ([Id], [Type]) VALUES (5, N'ShowTitle + SeasonLetter + SeasonZero + SeasonNoSpace + EpisodeLetter + EpisodeZero + Episode +')
INSERT [dbo].[TvShow_FileMatchTypes] ([Id], [Type]) VALUES (6, N'ShowTitle + dotNoSpace + SeasonLetterNoSpace + SeasonZero + SeasonNoSpace + EpisodeLetterNoSpace + EpisodeZero + Episode +')
INSERT [dbo].[TvShow_FileMatchTypes] ([Id], [Type]) VALUES (7, N'ShowTitle + dotNoSpace + SeasonLetterNoSpace + SeasonZero + SeasonNoSpace + EpisodeLetterNoSpace + EpisodeZero + Episode + dotNoSpace + EpisodeTitleNoSpace +')
INSERT [dbo].[TvShow_FileMatchTypes] ([Id], [Type]) VALUES (8, N'ShowTitle + SeasonLetter + SeasonZero + SeasonNoSpace + EpisodeLetterNoSpace + EpisodeZero + Episode + dash + EpisodeTitle +')
INSERT [dbo].[TvShow_FileMatchTypes] ([Id], [Type]) VALUES (9, N'ShowTitle + dotNoSpace + SeasonZero + SeasonNoSpace + xNoSpace + EpisodeZero + Episode +')
INSERT [dbo].[TvShow_FileMatchTypes] ([Id], [Type]) VALUES (10, N'ShowTitle + dotNoSpace + SeasonNoSpace + xNoSpace + EpisodeZero + Episode +')
INSERT [dbo].[TvShow_FileMatchTypes] ([Id], [Type]) VALUES (11, N'ShowTitle + dotNoSpace + SeasonLetterNoSpace + SeasonNoSpace + EpisodeLetterNoSpace + EpisodeZero + Episode +')
INSERT [dbo].[TvShow_FileMatchTypes] ([Id], [Type]) VALUES (13, N'ShowTitle + dashSpace + SeasonNoSpace + xNoSpace + EpisodeZero + Episode +')
INSERT [dbo].[TvShow_FileMatchTypes] ([Id], [Type]) VALUES (14, N'ShowTitle + dashSpace + SeasonZero + SeasonNoSpace + xNoSpace + EpisodeZero + Episode +')
INSERT [dbo].[TvShow_FileMatchTypes] ([Id], [Type]) VALUES (12, N'ShowTitle + dotNoSpace + SeasonLetterNoSpace + SeasonNoSpace + EpisodeLetter + EpisodeZero + Episode +')
/****** Object:  Table [dbo].[TvShow_FileMatch]    Script Date: 11/23/2011 11:56:14 ******/
SET IDENTITY_INSERT [dbo].[TvShow_FileMatch] ON
INSERT [dbo].[TvShow_FileMatch] ([Id], [Type]) VALUES (1, N'ShowTitle + dash + Season + dotNoSpace + EpisodeZero + Episode + EpisodeTitle +')
INSERT [dbo].[TvShow_FileMatch] ([Id], [Type]) VALUES (2, N'ShowTitle + SeasonLetter + SeasonZero + SeasonNoSpace + EpisodeLetterNoSpace + EpisodeZero + Episode +')
INSERT [dbo].[TvShow_FileMatch] ([Id], [Type]) VALUES (3, N'ShowTitle + dash + Season + xNoSpace + EpisodeZero + Episode +')
INSERT [dbo].[TvShow_FileMatch] ([Id], [Type]) VALUES (4, N'ShowTitle + SeasonLetter + SeasonZero + SeasonNoSpace + EpisodeLetter + EpisodeZero + Episode + dash + EpisodeTitle +')
INSERT [dbo].[TvShow_FileMatch] ([Id], [Type]) VALUES (5, N'ShowTitle + SeasonLetter + SeasonZero + SeasonNoSpace + EpisodeLetter + EpisodeZero + Episode +')
INSERT [dbo].[TvShow_FileMatch] ([Id], [Type]) VALUES (6, N'ShowTitle + dotNoSpace + SeasonLetterNoSpace + SeasonZero + SeasonNoSpace + EpisodeLetterNoSpace + EpisodeZero + Episode +')
INSERT [dbo].[TvShow_FileMatch] ([Id], [Type]) VALUES (8, N'ShowTitle + dotNoSpace + SeasonLetterNoSpace + SeasonZero + SeasonNoSpace + EpisodeLetterNoSpace + EpisodeZero + Episode + dotNoSpace + EpisodeTitleNoSpace +')
INSERT [dbo].[TvShow_FileMatch] ([Id], [Type]) VALUES (9, N'ShowTitle + SeasonLetter + SeasonZero + SeasonNoSpace + EpisodeLetterNoSpace + EpisodeZero + Episode + dash + EpisodeTitle +')
INSERT [dbo].[TvShow_FileMatch] ([Id], [Type]) VALUES (10, N'ShowTitle + dotNoSpace + SeasonZero + SeasonNoSpace + xNoSpace + EpisodeZero + Episode +')
SET IDENTITY_INSERT [dbo].[TvShow_FileMatch] OFF
/****** Object:  Table [dbo].[Media_GenreList]    Script Date: 11/23/2011 11:56:14 ******/
SET IDENTITY_INSERT [dbo].[Media_GenreList] ON
INSERT [dbo].[Media_GenreList] ([Id], [GenreTitle]) VALUES (1, N'Action')
INSERT [dbo].[Media_GenreList] ([Id], [GenreTitle]) VALUES (2, N'Adventure')
INSERT [dbo].[Media_GenreList] ([Id], [GenreTitle]) VALUES (3, N'Animation')
INSERT [dbo].[Media_GenreList] ([Id], [GenreTitle]) VALUES (4, N'Biography')
INSERT [dbo].[Media_GenreList] ([Id], [GenreTitle]) VALUES (5, N'Comedy')
INSERT [dbo].[Media_GenreList] ([Id], [GenreTitle]) VALUES (6, N'Crime')
INSERT [dbo].[Media_GenreList] ([Id], [GenreTitle]) VALUES (7, N'Documentary')
INSERT [dbo].[Media_GenreList] ([Id], [GenreTitle]) VALUES (8, N'Drama')
INSERT [dbo].[Media_GenreList] ([Id], [GenreTitle]) VALUES (9, N'Family')
INSERT [dbo].[Media_GenreList] ([Id], [GenreTitle]) VALUES (10, N'Fantasy')
INSERT [dbo].[Media_GenreList] ([Id], [GenreTitle]) VALUES (11, N'Film-Noir')
INSERT [dbo].[Media_GenreList] ([Id], [GenreTitle]) VALUES (12, N'Game-Show')
INSERT [dbo].[Media_GenreList] ([Id], [GenreTitle]) VALUES (13, N'History')
INSERT [dbo].[Media_GenreList] ([Id], [GenreTitle]) VALUES (14, N'Horror')
INSERT [dbo].[Media_GenreList] ([Id], [GenreTitle]) VALUES (15, N'Music')
INSERT [dbo].[Media_GenreList] ([Id], [GenreTitle]) VALUES (16, N'Musical')
INSERT [dbo].[Media_GenreList] ([Id], [GenreTitle]) VALUES (17, N'Mystery')
INSERT [dbo].[Media_GenreList] ([Id], [GenreTitle]) VALUES (18, N'News')
INSERT [dbo].[Media_GenreList] ([Id], [GenreTitle]) VALUES (19, N'Reality-TV')
INSERT [dbo].[Media_GenreList] ([Id], [GenreTitle]) VALUES (20, N'Romance')
INSERT [dbo].[Media_GenreList] ([Id], [GenreTitle]) VALUES (21, N'Sci-Fi')
INSERT [dbo].[Media_GenreList] ([Id], [GenreTitle]) VALUES (22, N'Sport')
INSERT [dbo].[Media_GenreList] ([Id], [GenreTitle]) VALUES (23, N'Talk-Show')
INSERT [dbo].[Media_GenreList] ([Id], [GenreTitle]) VALUES (24, N'Thriller')
INSERT [dbo].[Media_GenreList] ([Id], [GenreTitle]) VALUES (25, N'War')
INSERT [dbo].[Media_GenreList] ([Id], [GenreTitle]) VALUES (26, N'Western')
SET IDENTITY_INSERT [dbo].[Media_GenreList] OFF
/****** Object:  Table [dbo].[Main_TopNavMenu]    Script Date: 11/23/2011 11:56:14 ******/
SET IDENTITY_INSERT [dbo].[Main_TopNavMenu] ON
INSERT [dbo].[Main_TopNavMenu] ([Id], [MenuText], [PageName], [ControllerName], [RoleId], [IsActive]) VALUES (1, N'Home', N'Index', N'Home', 1, 1)
INSERT [dbo].[Main_TopNavMenu] ([Id], [MenuText], [PageName], [ControllerName], [RoleId], [IsActive]) VALUES (2, N'Movies', N'Index', N'Movie', 1, 1)
INSERT [dbo].[Main_TopNavMenu] ([Id], [MenuText], [PageName], [ControllerName], [RoleId], [IsActive]) VALUES (3, N'Tv Shows', N'Index', N'Tv', 1, 1)
INSERT [dbo].[Main_TopNavMenu] ([Id], [MenuText], [PageName], [ControllerName], [RoleId], [IsActive]) VALUES (4, N'About', N'About', N'Home', 1, 1)
INSERT [dbo].[Main_TopNavMenu] ([Id], [MenuText], [PageName], [ControllerName], [RoleId], [IsActive]) VALUES (5, N'Downloads', N'Index', N'Downloads', 2, 1)
INSERT [dbo].[Main_TopNavMenu] ([Id], [MenuText], [PageName], [ControllerName], [RoleId], [IsActive]) VALUES (6, N'Admin', N'Index', N'Admin', 3, 1)
SET IDENTITY_INSERT [dbo].[Main_TopNavMenu] OFF
/****** Object:  Table [dbo].[Main_PageContent]    Script Date: 11/23/2011 11:56:14 ******/
SET IDENTITY_INSERT [dbo].[Main_PageContent] ON
INSERT [dbo].[Main_PageContent] ([Id], [PageId], [ContentName], [PageContent], [CreatedBy], [CreatedDate]) VALUES (3, 1, N'Intro', N'<p>Welcome to the Home Page</p><p>This website will allow you to list your movies/tv shows from a directory you select</p><p>It will also allow you to setup links inside this web app to your downloader sites such as utorrent webui, sab, couch potato, sickbeard etc...</p>', N'Rob', CAST(0x00009F810083F220 AS DateTime))
INSERT [dbo].[Main_PageContent] ([Id], [PageId], [ContentName], [PageContent], [CreatedBy], [CreatedDate]) VALUES (4, 2, N'AboutInfo', N'<p>This is where the info for the about page would go.</p>
          Edit the text from the database in the table Media_pageContent</p>', N'Rob', CAST(0x00009F8100899A90 AS DateTime))
SET IDENTITY_INSERT [dbo].[Main_PageContent] OFF
/****** Object:  Table [dbo].[Main_Page]    Script Date: 11/23/2011 11:56:14 ******/
SET IDENTITY_INSERT [dbo].[Main_Page] ON
INSERT [dbo].[Main_Page] ([Id], [ControllerName], [PageName], [IsActive], [CreatedBy], [CreatedDate]) VALUES (1, N'Home', N'Index', 1, N'Rob', CAST(0x00009F810083ACFC AS DateTime))
INSERT [dbo].[Main_Page] ([Id], [ControllerName], [PageName], [IsActive], [CreatedBy], [CreatedDate]) VALUES (2, N'Home', N'About', 1, N'Rob', CAST(0x00009F810083ACFC AS DateTime))
SET IDENTITY_INSERT [dbo].[Main_Page] OFF
/****** Object:  Table [dbo].[Main_FileTypes]    Script Date: 11/23/2011 11:56:14 ******/
SET IDENTITY_INSERT [dbo].[Main_FileTypes] ON
INSERT [dbo].[Main_FileTypes] ([Id], [FileType], [IsActive]) VALUES (1, N'.mkv', 1)
INSERT [dbo].[Main_FileTypes] ([Id], [FileType], [IsActive]) VALUES (2, N'.avi', 1)
INSERT [dbo].[Main_FileTypes] ([Id], [FileType], [IsActive]) VALUES (3, N'.mp4', 1)
INSERT [dbo].[Main_FileTypes] ([Id], [FileType], [IsActive]) VALUES (4, N'.m4v', 1)
INSERT [dbo].[Main_FileTypes] ([Id], [FileType], [IsActive]) VALUES (5, N'.txt', 1)
SET IDENTITY_INSERT [dbo].[Main_FileTypes] OFF
/****** Object:  Table [dbo].[Main_Directory]    Script Date: 11/23/2011 11:56:14 ******/
SET IDENTITY_INSERT [dbo].[Main_Directory] ON
INSERT [dbo].[Main_Directory] ([Id], [Name], [Directory], [IsActive], [CreatedDate]) VALUES (1, N'Movies', N'\\robsshare\mac\media\movies', 1, NULL)
INSERT [dbo].[Main_Directory] ([Id], [Name], [Directory], [IsActive], [CreatedDate]) VALUES (2, N'Tv Shows', N'\\robsshare\mac\media\tv shows', 1, NULL)
INSERT [dbo].[Main_Directory] ([Id], [Name], [Directory], [IsActive], [CreatedDate]) VALUES (3, N'MovieTest', N'c:\Movies', 1, NULL)
INSERT [dbo].[Main_Directory] ([Id], [Name], [Directory], [IsActive], [CreatedDate]) VALUES (4, N'Movie Poster', N'../../Content/MediaImages/Posters/', 1, NULL)
INSERT [dbo].[Main_Directory] ([Id], [Name], [Directory], [IsActive], [CreatedDate]) VALUES (5, N'Tv Banners', N'../../Content/MediaImages/Tv Shows/', 1, NULL)
INSERT [dbo].[Main_Directory] ([Id], [Name], [Directory], [IsActive], [CreatedDate]) VALUES (6, N'Tv Banner Site', N'http://www.thetvdb.com/banners/', 1, NULL)
SET IDENTITY_INSERT [dbo].[Main_Directory] OFF